How to: Create header for groups that span multiple pages.
Solution:
In the Report Design view, select the 'View' menu and select 'Sorting and Grouping'. Use the 'Group Header' property box for the selected field(s) in the 'Group Properties' window to create headers for groups that span multiple pages in a report.
1) If the Database window is not active, activate the Database window.
2) Click the 'Reports' tab in the Database window.
Reports tab
3) Select the desired report from the list box. (The selected report is highlighted.)
4) Click 'Design'. (The selected report appears in the Design view, and the floating Toolbox appears.)
5) Select the 'View' menu and select 'Sorting and Grouping'. (The Sorting and Grouping dialog box appears.)
Grouping dialog box
6) Click on the desired grouping field in the 'Fields/Expression' box. (The Group Properties window appears at the bottom of the dialog box.)
7) Click on the 'Group Header' box. (A down arrow appears.)
8) Click down arrow. (A drop-down list appears.)
9) Select 'Yes' from the 'Group Header' drop-down list. (The selected field will be grouped in the header.)
10) Repeat steps 6) through 9) for each additional group header.
11) Click on the 'X' in the upper right corner of the 'Sorting and Grouping' window to close.
12) Select the 'File' menu and select 'Save' to save the report.
